
CREATE INDEX IX_ORDERSUFFIX ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([OrderSuffix], [OrderTypeCode]) INCLUDE ([SourceID], [OrderNumber])	

CREATE INDEX IX_SOURCEID  ON [RD_InventoryMart].[dbo].[Inventory_Star_FactsDetails] ([SourceID], [ItemNumber], [BusinessUnitCode], [Location], [LotNumber], [TimeOfDay], [UserID], [UniqueKeyIDInternal], [TransactionType], [GLDateID], [CreationDateID])	

CREATE INDEX IX_ItemNumber ON [RD_COMMON].[dbo].[Star_Item] ([SalesCategory01Code]) INCLUDE ([ItemNumberID], [SourceID], [ItemNumber], [ItemNumber02], [Description01], [SalesCategory01], [SalesCategory02Code], [SalesCategory02], [SalesCategory03Code], [SalesCategory03], [SalesCategory04Code], [SalesCategory04])	
CREATE INDEX IX_FactsHdrID ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([BusinessUnitID]) INCLUDE ([FactsHdrID], [CustomerNumberID], [ItemNumberID], [SourceID], [OrderNumberDocumentCompany], [OrderNumber], [OrderTypeCode], [LineNumber], [ShiptoNumber], [ItemNumber], [InvoiceDateID], [UnitOfMeasureAsInput])	
CREATE INDEX IX_UoMasInput ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([UnitOfMeasureAsInput]) INCLUDE ([SourceID], [ItemNumber])	
CREATE INDEX IX_InvoiceDateIDBusinessUnitID ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([InvoiceDateID], [ParentNumber]) INCLUDE ([CustomerNumberID], [OrderNumber], [BusinessUnitCode], [ShiptoNumber], [ItemNumber], [ItemNumber02], [QuantityShipped], [ExtendedPrice], [UnitOfMeasureAsInput])	
CREATE INDEX IX_InvoiceDateIDOrderNumber ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([InvoiceDateID], [ParentNumber]) INCLUDE ([CustomerNumberID], [SourceID], [OrderNumberDocumentCompany], [OrderNumber], [OrderTypeCode], [LineNumber], [BusinessUnitCode], [ShiptoNumber], [ItemNumber], [ItemNumber02], [QuantityShipped], [ExtendedPrice], [UnitOfMeasureAsInput])	
CREATE INDEX IX_OrderTypeCode ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([OrderTypeCode]) INCLUDE ([FactsExtID], [FactsHdrID], [SourceID], [OrderNumberDocumentCompany], [OrderNumber], [LineNumber], [OrderSuffix], [TransactionType], [BusinessUnitCode], [AddressNumber], [ItemNumber], [RequestedDateID], [ForecastType], [YearCalendarYear])	
CREATE INDEX IX_SourceID ON [RD_GLMart].[dbo].[GL_Star_FactsDetails] ([SourceID], [DocumentCompany], [DocumentType], [DocumentNumber], [JournalEntryLineNumber], [LineExtensionCode], [LedgerTypeCode], [GLDateID])	
CREATE INDEX IX_ExpireDate ON [RD_SalesMart].[dbo].[Sales_Star_PriceAdjustment] ([ExpiredDate]) INCLUDE ([PriceAdjustmentKeyID])	
CREATE INDEX IX_FactExtID ON [RD_SalesMart].[dbo].[Sales_Star_Facts] ([OrderTypeCode]) INCLUDE ([FactsExtID], [SourceID], [OrderNumberDocumentCompany], [OrderNumber], [LineNumber], [OrderSuffix], [TransactionType], [BusinessUnitCode], [AddressNumber], [ItemNumber], [ForecastType], [YearCalendarYear])	
